﻿CREATE TABLE [dbo].[ScribeShiftTimeLocation]
(
	[Id] INT NOT NULL PRIMARY KEY, 
    [ScribeId] INT NULL, 
    [ShiftTimeId] INT NULL,
	[LocationId] INT NULL,
	CONSTRAINT FK_ScribeShiftTimeLocation_ScribeId FOREIGN KEY ([ScribeID]) REFERENCES Scribe(Id),
	CONSTRAINT FK_ScribeShiftTimeLocation_ShiftTimeId FOREIGN KEY (ShiftTimeId) REFERENCES ShiftTime(Id),
	CONSTRAINT FK_ScribeShiftTimeLocation_LocationId FOREIGN KEY ([LocationId]) REFERENCES Location(Id),
)
